After you've finished the Beginner, Expert, and Advanced series, move up to the Developer series to learn how to super-charge your databases. This is the pinnacle of my Microsoft Access training and is where we unlock the true power of Access with Visual Basic for Applications (VBA). Here you'll learn how to automate tasks, build custom interfaces, create reusable code, work with recordsets, manipulate files, integrate with other Office applications, customize ribbons and menus, build complex business systems, and solve real-world problems that simply can't be accomplished with tables, queries, forms, reports, macros, and events alone. These lessons are designed to teach you how to think like a professional developer, not just how to write code. Whether you're building a database for yourself, your business, or your clients, the Developer series will give you the tools and techniques needed to transform Microsoft Access from a database application into a complete custom software development platform.

Microsoft Access Developer Courses			Options Sort: Date Title   |   Display: Full Compact
	Access Developer 1 Get started with VBA programming in Microsoft Access as you learn how to create your first code using the MsgBox command, open forms with DoCmd.OpenForm, and convert macros to powerful VBA subroutines. Explore essential topics like building If Then logic, automating data entry with the AfterUpdate event, handling multi-step commands, and linking form controls to improve productivity. Unlock practical skills that enable you to enhance and automate your Access databases using VBA, with hands-on guidance covering form events, working with parameters, and best practices for structuring robust code.
	Access Developer 2 Take your Access skills to the next level by building a custom calculator form and a commission tracking form using VBA programming. Learn to create and streamline calculator operations with custom subroutines and Select Case statements, implement data validation and error handling, and automate data entry into tables using DoCmd.RunSQL with SQL INSERT statements. Along the way, you'll pick up best practices for managing null and blank values, user input validation, and practical form design, giving you hands-on experience with real-world automation solutions.
	Access Developer 3 Build advanced database solutions with memory variables, random numbers, constants, and For Next loops in this practical course for Access developers. Learn to check for duplicate records using DLookup, prompt users for confirmation, create a math quiz using random number generation, and manage user input and quiz scoring with different variable types. The course also covers quick data entry techniques like adding new sales reps directly from forms with input boxes and combo boxes, along with error handling, best practices, and tips for smoother workflow and automation in your Access projects.
	Access Developer 4 Build your skills with advanced features by learning how to add and manage editable notes on order details, implement tiered sales commissions based on order amounts, and streamline your commission tracking using tables, forms, and VBA techniques. This course covers updating the order system for custom notes, designing dynamic forms to assign and calculate commissions for employees, and connecting orders to reps for easy payment management. You will also learn to enhance form usability, update printable invoices, and organize VBA for efficient, real-world database solutions.
	Access Developer 5 Build advanced skills by creating a pay commissions system, including forms with dual list boxes for managing commission items, processing payments, and designing reports to print checks with both numeric and currency text amounts using a spell number function. The course covers best practices for commission approval, handling multi-user data integrity, automating check numbering, marking checks as printed, and tips for aligning check reports. You will also learn to manage form selections, efficiently update related records, and set up your database for secure, streamlined employee commission tracking and check printing.
	Access Developer 6 Take your Access databases to the next level by learning how to convert macros to VBA for more control and automation, create enhanced timer forms for scheduled actions, build dynamic cascading combo boxes to improve data filtering, and set up automated backups to safeguard both your entire database and individual objects. This course covers when to use Access's built-in tools versus manual VBA, methods for interval-based automation, and best practices to keep your data secure and efficient.
	Access Developer 7 Partial Payments on Invoices, Refreshing Subforms in VBA, Form ! Subform Notation, vbExclamation, vbCritical, Don't Allow Payments if PAID, NZ Function to Handle Null Payments, Hide Fields on Invoice by Criteria, Can Shrink Issue for Hidden Fields, Adding Missing Fields to Subforms
	Access Developer 8 More Partial Payments Invoices, Combo DropDown Method, On Unload Event, Locking Invoices if Paid, Creating a Public Global Function, Globally Search VBA Code, Allow Additions, Edits, Deletions VBA, Search As You Type, On Key Press, On Change Events
	Access Developer 9 Add Search Form to Main Menu, Fixing Delete a Payment Problem, Lock or Unlock if Invoice Paid, Test Taker Database, Part 1, Table Setup, Relationships, Ref Integrity, Dept, Class, Test, Question, Answer, Multiple Choice v. Fill in the Blank, Continuous Form with Subform, Begin Taking Test, Save All Results
	Access Developer 10 Test Taker Database, Part 2, Determine Which Question to Ask, Display List Box for Multiple Choice, Display Text Box for Fill-in-the-Blank, Check Answer for Correctness, Store Results in Session Answer Table, Calculate Student's Grade, Store Results in Answer Table, NZ, StrComp, Round Functions
	Access Developer 11 Test Taker Database, Part 3, Display Question 1 of X, Close Child Forms if Parent Closed, Tracking Start and End Times, Display Timer on Form, Timeout, RGB Function and Colors, Calculate Elapsed Time, Universal Dialog Box, Part 1, Customized uDialog Box with Options
	Access Developer 12 Universal Dialog Box, Parts 2 & 3, Add OK, Cancel Buttons, DoEvents in Timer Loops, Global Variables, While Loops, Custom Form Positioning, Move, Resize Form Windows VBA, Twips, InsideHeight, InsideWidth, External String Manager, Dynamic Labels on Forms and Reports
	Access Developer 13 Search Between Dates, Before, After, Between Date Search, Select Case Control Structure, Tuition With Multiple Options, Billing on Grade Level, Variable Discounts Applicable, Same as Products w Different Features, Multi Field Index / Composite Keys, Pricing Wizard Form
	Access Developer 14 How To Design a Customizable Point of Sale System Database Step by Step in Microsoft Access
	Access Developer 15 How To Use Multi-Select List Boxes and Advanced Debugging Techniques in Microsoft Access Developer 15
	Access Developer 16 How To Format Listbox Colors Multi-Select and Work With Recordsets in Microsoft Access Developer 16
	Access Developer 17 How To Remove Multi-Select Listbox Items Export PDF Reports and Use DLookupPlus in Microsoft Access
	Access Developer 18 How To Build Custom Progress Bars and Unbound Forms With Recordset Navigation in Microsoft Access
	Access Developer 19 How To Build Bound Multi-Select Listboxes, Nested Recordsets, and Chef's Kitchen Helper in Microsoft Access
	Access Developer 20 How To Connect Recordsets To External Databases And Build TreeView Controls in Microsoft Access
	Access Developer 21 How To Scrub Data, Create Nested and Side by Side Continuous Forms, and Use Arrays in Microsoft Access
	Access Developer 22 How To Use Tag Property, Apply Payments to Orders, and Count Records with Recordsets in Microsoft Access
	Access Developer 23 How To Track Rental Inventory, Scan Barcodes, and Build Order Entry Systems in Microsoft Access
	Access Developer 24 How To Build a Reservation System and Copy Orders With Details Using Recordsets in Microsoft Access
	Access Developer 25 How To Use ByRef and ByVal, Active Form and Control, and Product Groups in Microsoft Access
	Access Developer 26 How To Build Advanced Search Forms With Dynamic Criteria Tables And Filtering In Microsoft Access
	Access Developer 27 How To Scan, Print, and Track Barcodes, QR Codes, and Serial Numbers for Inventory in Microsoft Access
	Access Developer 28 How To Use Form Criteria for Reports, Customer Pricing, and Time Billing Automation in Microsoft Access
	Access Developer 29 How To Manage Product Components and FIFO Stock Rotation for Inventory Databases in Microsoft Access
	Access Developer 30 How To Read and Write Text Files Using Classic VB File Input Output Techniques in Microsoft Access
	Access Developer 31 How To Navigate Files, Copy and Rename Files, and Compact Backend Databases in Microsoft Access
	Access Developer 32 How To Export Reports as HTML, FTP Files, Convert Currency, and Search Groups in Microsoft Access
	Access Developer 33 How To Relink Tables, Manage ODBC Connections, and Use File System Object for File IO in Microsoft Access
	Access Developer 34 How To Use File System Object For Reading Writing Exporting Importing Text Files in Microsoft Access
	Access Developer 35 How To Use File System Object Drive Properties and Not In List Event Handling in Microsoft Access
	Access Developer 36 How To Prevent Duplicates With Composite Keys, SQL NOT IN, And Customer Product Queries in Microsoft Access
	Access Developer 37 How To Build Custom List Box Columns With Dynamic Fields and QueryDefs in Microsoft Access
	Access Developer 38 How To Replace Multi-Valued Fields and Create Multi-Column Forms With Images in Microsoft Access
	Access Developer 39 How To Build a Searchable Document Index With Keyword Search and Word Automation in Microsoft Access
	Access Developer 40 How To Create Event Countdown Timers, Custom Color Editors, and Conditional Formatting in Microsoft Access
	Access Developer 41 How To Zoom In And Out of Forms, Anchor Controls, and Handle Form Errors in Microsoft Access
	Access Developer 42 How To Use Parameter Arrays and Build Products With Options in Microsoft Access Developer Level 42
	Access Developer 43 How To Replace Append Only Long Text Fields and Use TempVars in VBA for Microsoft Access Databases
	Access Developer 44 How To Build Custom Ribbons With XML, Callback Functions, Icons, and VBA in Microsoft Access
	Access Developer 45 How To Customize Ribbons, Backstage Menus, Quick Access Toolbars, and Context Menus in Microsoft Access
	Access Developer 46 How To Build a Multi-Level Undo System With Change Log and Custom Delete Button in Microsoft Access
	Access Developer 47 How To Open Multiple Form Instances Track With Collections Cascade Layered Windows in Microsoft Access
	Access Developer 48 How To Copy Records Without Specifying Field Names Using VBA and Indexes in Microsoft Access
	Access Developer 49 How To Use Transactions Dynamic Temp Tables and Navigation Subforms in Microsoft Access
	Access Developer 50 How To Use Class Modules, User Defined Types, Encapsulation, Properties, and Methods in Microsoft Access
	Access Developer 51 How To Build Modal Pop Up Forms, Safe Delete Loops, and File Drop Systems in Microsoft Access
	Access Developer 52 Building a Complete File Drop System, File Thumbnails & Image Previews, File Type Icons, Media Folder Organization, Custom Preview Functions, Performance Optimization, Open Link or File Function, Launching Files & Folders, Command Line Parameters, Access Database Automation, Web Hyperlink Detection, ShellExecute Integration, Excel Automation, Jump to Worksheets, Word Automation, Heading Navigation, Text Search Fallback, Object Cleanup & Error Handling
	Access Developer 53 How To Build a Recycle Bin, Batch Import, and Automate Word Docs in Microsoft Access
	Access Developer 54 How To Build a Split Transaction System With Rollback and Percentage Splits in Microsoft Access
	Access Developer 55 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today
	Access Developer 56 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today
	Access Developer 57 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today
	Access Developer 58 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today
	Access Developer 59 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today
	Access Developer 60 This course is currently under development. Enroll now and you can possibly join in, ask questions, and provide feedback while the class is in progress. Sign up today